[dbo].[CompanyNaicsSic]

Property	Value
Row Count	0
Created	10:31:17 AM Tuesday, March 02, 2010
Last Modified	11:40:01 AM Monday, February 20, 2012

Property

Value

Row Count

Created

10:31:17 AM Tuesday, March 02, 2010

Last Modified

11:40:01 AM Monday, February 20, 2012

	Name	Data Type	Max Length (Bytes)
$Cluster Primary Key PK_CompanyNaicsSic: ContactKey\NaicsSicCode$	ContactKey	uniqueidentifier	16
$Cluster Primary Key PK_CompanyNaicsSic: ContactKey\NaicsSicCode$	NaicsSicCode	int	4
	IsSic	bit	1
	MarkedForDeleteOn	datetime	8

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Cluster Primary Key PK_CompanyNaicsSic: ContactKey\NaicsSicCode$

ContactKey

uniqueidentifier

$Cluster Primary Key PK_CompanyNaicsSic: ContactKey\NaicsSicCode$

NaicsSicCode

int

IsSic

bit

MarkedForDeleteOn

datetime

	Name	Columns	Unique
$Cluster Primary Key PK_CompanyNaicsSic: ContactKey\NaicsSicCode$	PK_CompanyNaicsSic	ContactKey, NaicsSicCode
	IX_CompanyNaicsSic_NaicsSicCode	NaicsSicCode

Name

Columns

Unique

$Cluster Primary Key PK_CompanyNaicsSic: ContactKey\NaicsSicCode$

PK_CompanyNaicsSic

ContactKey, NaicsSicCode

IX_CompanyNaicsSic_NaicsSicCode

NaicsSicCode

Name	Columns
FK_CompanyNaicsSic_Institute	ContactKey->[dbo].[Institute].[ContactKey]

Name

Columns

FK_CompanyNaicsSic_Institute

ContactKey->[dbo].[Institute].[ContactKey]

SQL Script

CREATE TABLE [dbo].[CompanyNaicsSic]
(
[ContactKey] [uniqueidentifier] NOT NULL,
[NaicsSicCode] [int] NOT NULL,
[IsSic] [bit] NOT NULL,
[MarkedForDeleteOn] [datetime] NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[CompanyNaicsSic] ADD CONSTRAINT [PK_CompanyNaicsSic] PRIMARY KEY CLUSTERED ([ContactKey], [NaicsSicCode]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_CompanyNaicsSic_NaicsSicCode] ON [dbo].[CompanyNaicsSic] ([NaicsSicCode]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[CompanyNaicsSic] ADD CONSTRAINT [FK_CompanyNaicsSic_Institute] FOREIGN KEY ([ContactKey]) REFERENCES [dbo].[Institute] ([ContactKey])
GO